home *** CD-ROM | disk | FTP | other *** search
/ Developer Source 7 / developer source - volume 7.iso / orinf / mar97 / hipsf102.gif < prev    next >
Graphics Interchange Format  |  1997-06-27  |  22KB  |  333x320  |  4-bit (16 colors)
Labels: text | electronics | screenshot | display | software | number
OCR: Oracle Procedure Builder File Edit Tools Window Help Stored Program Unit . SCOTT ANNUM _ SAL_UPDATE Now ISayel Hevet Diep Cloud SCOTT # Name ANNUAL_SAL_UPDATE (Proc PROCEDURE annual_sal_update IS emp nua number; new_sal number ; cursor new salaries is select empno, sal_increase(empno) BEGIN From emp; open new salaries; 1cop fetch new_salaries into emp_num, new_sal; if new salaries NOTFOUND then exit; end if; update cap set sal = new_sal where empno = emp_num; end loop; close new salaries; END No Moddied Figure 2: A procedure that updates employee salaries,